Skip to content
  • Try Smartsheet

    • David Bright

    David Bright

    David Bright ✭✭✭✭

    Overview

    Overview
    Roles
    Member
    Badges22

    About Me

    About Me
    Area of ExpertiseProcess Development
    About MeOperations Manager

    Analytics

    18
    12
    1.1k

    Reactions

    • Re: Countifs with Distinct?

      Thanks Everyone, Based on the samples provided, I was able to get my scenario solved by using a combination of COUNT, DISTINCT, and COLLECT. It ended up looking like this: =COUNT(DISTINCT(COLLECT({Em…
      ·
    Avatar

    Badges

    • Community 10th Anniversary
    • $1B in annualized recurring revenue
    • 5 Up Votes
    • Engage 2021: Together we build
    • Sixth Anniversary
    • Engage: All IN 2021
    • Early Adopters Program
    • Engage 2020
    • First Comment
    • 10 Comments
    • First Anniversary
    • Second Anniversary
    • Third Anniversary
    • Fourth Anniversary
    • Fifth Anniversary
    • Solution Certified 2018
    • Engage 2018
    • certification2018
    • (Legacy) discussion-1
    • (Legacy) like-1